use hdp_lbg_supin_zplisting;

alter table hdp_lbg_supin_zplisting.raw_zp_58_zzlist
add if not exists partition (dt='${dateSuffix}')
location '/home/hdp_lbg_zhaopin/rawdata/zhuzhan/zplistinfonewlog/${dateSuffix}';